
export default {
  // 档案
  user_table: {
    options: [
      {label: '用户状态', value: 'f_user_state'},
      {label: '用户类型', value: 'f_user_type'},
      {label: '缴费类型', value: 'f_cost_type'}
    ],
    items: {
//      数目: 'count(f_userinfo_id) AS 数目 ',
      f_user_state: 'count(f_user_state) As value, f_user_state As name',
      f_user_type: 'count(f_user_type) As value, f_user_type As name',
      f_cost_type: 'count(f_cost_type) As value, f_cost_type As name'
    },
    condition: 'f_user_state',
    groupitem: '',
    orderitem: ''
  },
  userinfo: {
    options:
    [ {label: '用户状态', value: 'f_user_state'},
      {label: '用户类型', value: 'f_user_type'},
      {label: '缴费类型', value: 'f_cost_type'}
    ],
    items: {
//      数目: 'count(f_userinfo_id) AS 数目 ',
      f_user_state: 'count(f_user_state) As value, f_user_state As name',
      f_user_type: 'count(f_user_type) As value, f_user_type As name',
      f_cost_type: 'count(f_cost_type) As value, f_cost_type As name'
    },
    condition: '',
    groupitem: 'f_user_state',
    orderitem: ''
  },
  // 收费
  sellinggas: {
    options:
    [ {label: '气表类型', value: 'f_meter_type'},
      {label: '付款方式', value: 'f_payment'},
      {label: '用气性质', value: 'f_gasproperties'},
      {label: '收费类型', value: 'f_charge_type'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      用户上期结余: 'ROUND(SUM(f_balance),2) AS 用户上期结余 , ',
//      用户本期结余: 'ROUND(SUM(f_curbalance),2) AS 用户本期结余, ',
//      预购金额: 'ROUND(SUM(f_preamount),2) AS 预购金额, ',
//      预购气量: 'ROUND(SUM(f_pregas),2) AS 预购气量, ',
//      收款: 'ROUND(SUM(f_collection),2) AS 收款, ',
//      滞纳金: 'ROUND(SUM(f_delaypay),2) AS 滞纳金 ',
      f_meter_type: 'count(f_meter_type) As va, round(sum(f_preamount),2) As value, f_meter_type As name',
      f_payment: 'count(f_payment) As va, round(sum(f_preamount),2) As value,f_payment As name',
      f_gasproperties: 'count(f_gasproperties) As va, round(sum(f_preamount),2) As value,f_gasproperties As name',
      f_charge_type: 'count(f_charge_type) As va, round(sum(f_preamount),2) As value,f_charge_type As name'
    },
    condition: '',
    groupitem: 'f_meter_type',
    orderitem: ''
  },
  // 抄表
  handplan: {
    options:
    [ {label: '用户类型', value: 'f_user_type'},
      {label: '用气性质', value: 'f_gasproperties'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//      应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 ',
      f_user_type: 'count(f_user_type) As value, f_user_type As name',
      f_gasproperties: 'count(f_gasproperties) As value, f_gasproperties As name'
    },
    condition: '',
    groupitem: 'f_user_type',
    orderitem: ''
  },
  // 操作
  record: {
    options:
    [ {label: '操作类型', value: 'f_operat_type'}
    ],
    items: {
//      操作类型: 'f_operat_type AS 操作类型 , ',
//      操作条目数: 'COUNT(f_operat_type) AS 操作条目数 ',
      f_operat_type: 'count(f_operat_type) As value, f_operat_type As name'
    },
    condition: '',
    groupitem: 'f_operat_type',
    orderitem: ''
  },
  // 换表管理
  changemeter: {
    options:
    [ {label: '换表类型', value: 'f_changemeter_type'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//      应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 ',
      f_changemeter_type: 'count(f_changemeter_type) As value, f_changemeter_type As name'
    },
    condition: '',
    groupitem: 'f_changemeter_type',
    orderitem: ''
  },
  // 变更明细
  // infochange: {
  //   items: {
  //     data: 'count(id) AS 数目, ROUND(SUM(f_oughtamount),2) AS 应交气量 , ROUND(SUM(f_oughtfee),2) AS 应交金额 '
  //   },
  //   condition: '',
  //   groupitem: 'f_userinfo_id',
  //   orderitem: ''
  // },
  // 变更操作
//   recordchange: {
//     items: {
//       数目: 'count(id) AS 数目, ',
//       应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//       应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 '
//     },
//     condition: '',
//     groupitem: '',
//     orderitem: ''
//   },
  // 过户
  transfer: {
    items: {
      data: 'f_userinfo_id  AS 户编号 , COUNT(id) AS 过户次数 , ROUND(SUM(f_transfer_fees),2) AS 过户总金额'
    },
    condition: '',
    groupitem: 'f_userinfo_id',
    orderitem: ''
  },
  // 冲正
  correctrecord: {
    options:
    [ {label: '冲正类型', value: 'f_correct_type'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//      应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 ',
      f_correct_type: 'count(f_correct_type) As value, f_correct_type As name'
    },
    condition: '',
    groupitem: 'f_correct_type',
    orderitem: ''
  },
  // 补卡
  fillcard: {
    options:
    [ {label: '补卡类型', value: 'f_fillcard_type'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//      应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 ',
      f_fillcard_type: 'count(f_fillcard_type) As va,round(sum(f_cardfees),2) As value,f_fillcard_type As name'
    },
    condition: '',
    groupitem: 'f_fillcard_type',
    orderitem: ''
  },
  // 补气
  fillgas: {
    options:
    [ {label: '补气类型', value: 'f_fillgas_type'}
    ],
    items: {
//      数目: 'count(id) AS 数目, ',
//      应交气量: 'ROUND(SUM(f_oughtamount),2) AS 应交气量 , ',
//      应交金额: 'ROUND(SUM(f_oughtfee),2) AS 应交金额 ',
      f_fillgas_type: 'count(f_fillgas_type) As va,round(sum(f_fillgas),2) As value, f_fillgas_type As name'
    },
    condition: '',
    groupitem: 'f_fillgas_type',
    orderitem: ''
  }
}
